USE [RD_SalesMart]
GO

/****** Object:  Index [PK_JDESOSalesOrderDetail]    Script Date: 08/13/2010 21:50:11 ******/
ALTER TABLE [dbo].[Sales_Star_FactsExt] ADD  CONSTRAINT [PK_JDESOSalesOrderDetail] PRIMARY KEY CLUSTERED 
(
	[OrderNumber] ASC,
	[OrderNumberDocumentCompany] ASC,
	[LineNumber] ASC,
	[OrderTypeCode] ASC,
	[OrderSuffix] ASC,
	[TransactionType] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


USE [RD_SalesMart]
GO

/****** Object:  Index [IX_FactsExt_DateRelease]    Script Date: 08/13/2010 21:49:57 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_DateRelease] ON [dbo].[Sales_Star_FactsExt] 
(
	[DateReleaseID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_FactsExtID]    Script Date: 08/13/2010 21:49:57 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_FactsExtID] ON [dbo].[Sales_Star_FactsExt] 
(
	[FactsExtID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_PaymentTermsID]    Script Date: 08/13/2010 21:49:57 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_PaymentTermsID] ON [dbo].[Sales_Star_FactsExt] 
(
	[PaymentTermsID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_UserReservedDate]    Script Date: 08/13/2010 21:49:57 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_UserReservedDate] ON [dbo].[Sales_Star_FactsExt] 
(
	[UserReservedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_170]    Script Date: 08/13/2010 21:49:57 ******/
CREATE NONCLUSTERED INDEX [missing_index_170] ON [dbo].[Sales_Star_FactsExt] 
(
	[LotNumber] ASC
)
INCLUDE ( [FactsExtID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_299]    Script Date: 08/13/2010 21:49:57 ******/
CREATE NONCLUSTERED INDEX [missing_index_299] ON [dbo].[Sales_Star_FactsExt] 
(
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_394]    Script Date: 08/13/2010 21:49:57 ******/
CREATE NONCLUSTERED INDEX [missing_index_394] ON [dbo].[Sales_Star_FactsExt] 
(
	[GLOffset] ASC
)
INCLUDE ( [FactsExtID],
[PriceOverrideCode],
[DocumentNumber]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_925]    Script Date: 08/13/2010 21:49:57 ******/
CREATE NONCLUSTERED INDEX [missing_index_925] ON [dbo].[Sales_Star_FactsExt] 
(
	[PriceOverrideCode] ASC
)
INCLUDE ( [FactsExtID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_985]    Script Date: 08/13/2010 21:49:57 ******/
CREATE NONCLUSTERED INDEX [missing_index_985] ON [dbo].[Sales_Star_FactsExt] 
(
	[PriceOverrideCode] ASC
)
INCLUDE ( [FactsExtID],
[RouteCode]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


